Chicago Sidewalk Cafe Permits

Dataset statistics

Number of variables	22
Number of observations	22224
Missing cells	4915
Missing cells (%)	1.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.7 MiB
Average record size in memory	176.0 B

Variable types

Numeric	10
Text	5
DateTime	3
Categorical	4

Alerts

`CITY` has constant value ""	Constant
`STATE` has constant value ""	Constant
`ADDRESS NUMBER START` is highly overall correlated with `ADDRESS NUMBER` and 3 other fields	High correlation
`ADDRESS NUMBER` is highly overall correlated with `ADDRESS NUMBER START` and 3 other fields	High correlation
`WARD` is highly overall correlated with `POLICE DISTRICT` and 1 other fields	High correlation
`POLICE DISTRICT` is highly overall correlated with `ADDRESS NUMBER START` and 3 other fields	High correlation
`LATITUDE` is highly overall correlated with `ADDRESS NUMBER START` and 4 other fields	High correlation
`LONGITUDE` is highly overall correlated with `ADDRESS NUMBER START` and 2 other fields	High correlation
`STREET TYPE` is highly imbalanced (51.9%)	Imbalance
`STREET TYPE` has 1360 (6.1%) missing values	Missing
`POLICE DISTRICT` has 881 (4.0%) missing values	Missing
`LATITUDE` has 881 (4.0%) missing values	Missing
`LONGITUDE` has 881 (4.0%) missing values	Missing
`LOCATION` has 881 (4.0%) missing values	Missing
`PERMIT NUMBER` has unique values	Unique
`ADDRESS NUMBER START` has 2117 (9.5%) zeros	Zeros
`ADDRESS NUMBER` has 2117 (9.5%) zeros	Zeros

Reproduction

Analysis started	2023-11-14 23:04:59.309665
Analysis finished	2023-11-14 23:05:25.592951
Duration	26.28 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

PERMIT NUMBER
Real number (ℝ)

UNIQUE

Distinct	22224
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1173665.8

Minimum	1000571
Maximum	1866738
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	1000571
5-th percentile	1025232.3
Q1	1078125
median	1111338.5
Q3	1133270.8
95-th percentile	1694610
Maximum	1866738
Range	866167
Interquartile range (IQR)	55145.75

Descriptive statistics

Standard deviation	204435.56
Coefficient of variation (CV)	0.17418549
Kurtosis	2.9928554
Mean	1173665.8
Median Absolute Deviation (MAD)	25491
Skewness	2.1118273
Sum	2.6083549 × 10¹⁰
Variance	4.1793899 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1556602	1	< 0.1%
1121733	1	< 0.1%
1121742	1	< 0.1%
1121741	1	< 0.1%
1121739	1	< 0.1%
1121738	1	< 0.1%
1121737	1	< 0.1%
1121736	1	< 0.1%
1121735	1	< 0.1%
1121734	1	< 0.1%
Other values (22214)	22214	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000571	1	< 0.1%
1001307	1	< 0.1%
1002652	1	< 0.1%
1002993	1	< 0.1%
1003612	1	< 0.1%
1004393	1	< 0.1%
1007248	1	< 0.1%
1007265	1	< 0.1%
1007306	1	< 0.1%
1007406	1	< 0.1%

Value	Count	Frequency (%)
1866738	1	< 0.1%
1862206	1	< 0.1%
1860048	1	< 0.1%
1859432	1	< 0.1%
1857612	1	< 0.1%
1855208	1	< 0.1%
1854101	1	< 0.1%
1852797	1	< 0.1%
1852784	1	< 0.1%
1848630	1	< 0.1%

ACCOUNT NUMBER
Real number (ℝ)

Distinct	3299
Distinct (%)	14.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	210928.11

Minimum	12
Maximum	496618
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	12
5-th percentile	5310
Q1	23392
median	261427
Q3	352222.25
95-th percentile	421498
Maximum	496618
Range	496606
Interquartile range (IQR)	328830.25

Descriptive statistics

Standard deviation	157585.62
Coefficient of variation (CV)	0.74710579
Kurtosis	-1.5819454
Mean	210928.11
Median Absolute Deviation (MAD)	137671
Skewness	-0.11089776
Sum	4.6876664 × 10⁹
Variance	2.4833226 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63414	956	4.3%
65004	320	1.4%
298727	114	0.5%
50161	87	0.4%
230211	66	0.3%
22633	66	0.3%
369504	65	0.3%
17658	56	0.3%
392906	50	0.2%
267891	48	0.2%
Other values (3289)	20396	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	6	< 0.1%
13	23	0.1%
16	4	< 0.1%
27	4	< 0.1%
28	11	< 0.1%
46	18	0.1%
51	6	< 0.1%
66	2	< 0.1%
67	20	0.1%
73	17	0.1%

Value	Count	Frequency (%)
496618	1	< 0.1%
496437	1	< 0.1%
495513	1	< 0.1%
495456	1	< 0.1%
494737	1	< 0.1%
494369	1	< 0.1%
494267	1	< 0.1%
493688	1	< 0.1%
493639	1	< 0.1%
493621	1	< 0.1%

SITE NUMBER
Real number (ℝ)

Distinct	105
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.225027

Minimum	1
Maximum	230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	21
Maximum	230
Range	229
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	17.949894
Coefficient of variation (CV)	3.4353687
Kurtosis	44.370416
Mean	5.225027
Median Absolute Deviation (MAD)	0
Skewness	6.189469
Sum	116121
Variance	322.1987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	16344	73.5%
2	2562	11.5%
3	661	3.0%
4	318	1.4%
5	229	1.0%
7	124	0.6%
6	106	0.5%
11	98	0.4%
12	96	0.4%
19	94	0.4%
Other values (95)	1592	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16344	73.5%
2	2562	11.5%
3	661	3.0%
4	318	1.4%
5	229	1.0%
6	106	0.5%
7	124	0.6%
8	65	0.3%
9	77	0.3%
10	71	0.3%

Value	Count	Frequency (%)
230	1	< 0.1%
229	1	< 0.1%
228	1	< 0.1%
226	1	< 0.1%
225	1	< 0.1%
224	1	< 0.1%
221	1	< 0.1%
220	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%

LEGAL NAME
Text

Distinct	3312
Distinct (%)	14.9%
Missing	1
Missing (%)	< 0.1%
Memory size	173.8 KiB

Length

Max length	67
Median length	46
Mean length	21.106061
Min length	4

Characters and Unicode

Total characters	469040
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	724 ?
Unique (%)	3.3%

Sample

1st row	THE LIFEWAY KEFIR SHOP LLC
2nd row	JERRY'S SANDWICHES LS, LLC
3rd row	ETTA RIVER NORTH, LLC
4th row	SQUARE KITCHEN, LLC
5th row	ROCCO'S, LLC

Value	Count	Frequency (%)
inc	9846	12.9%
llc	6784	8.9%
corporation	1690	2.2%
restaurant	1543	2.0%
	1390	1.8%
starbucks	956	1.3%
chicago	935	1.2%
corp	928	1.2%
the	919	1.2%
cafe	756	1.0%
Other values (3904)	50335	66.2%

Most occurring characters

Value	Count	Frequency (%)
	54030	11.5%
C	33251	7.1%
I	31975	6.8%
A	31511	6.7%
N	30771	6.6%
L	29178	6.2%
O	28211	6.0%
R	27806	5.9%
E	27661	5.9%
T	22942	4.9%
Other values (68)	151704	32.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	368739	78.6%
Space Separator	54030	11.5%
Other Punctuation	29102	6.2%
Lowercase Letter	8832	1.9%
Decimal Number	7469	1.6%
Dash Punctuation	669	0.1%
Open Punctuation	92	< 0.1%
Close Punctuation	92	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	33251	9.0%
I	31975	8.7%
A	31511	8.5%
N	30771	8.3%
L	29178	7.9%
O	28211	7.7%
R	27806	7.5%
E	27661	7.5%
T	22942	6.2%
S	22261	6.0%
Other values (16)	83172	22.6%

Lowercase Letter

Value	Count	Frequency (%)
e	1006	11.4%
a	1004	11.4%
n	881	10.0%
o	736	8.3%
t	661	7.5%
r	639	7.2%
i	630	7.1%
s	563	6.4%
c	481	5.4%
l	420	4.8%
Other values (16)	1811	20.5%

Other Punctuation

Value	Count	Frequency (%)
.	12834	44.1%
,	12327	42.4%
'	2488	8.5%
&	1221	4.2%
#	98	0.3%
/	81	0.3%
"	38	0.1%
@	7	< 0.1%
!	6	< 0.1%
:	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	1393	18.7%
2	1051	14.1%
0	942	12.6%
5	889	11.9%
3	847	11.3%
4	793	10.6%
8	521	7.0%
6	383	5.1%
7	369	4.9%
9	281	3.8%

Space Separator

Value	Count	Frequency (%)
	54030	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	669	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	92	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	92	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	377571	80.5%
Common	91469	19.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	33251	8.8%
I	31975	8.5%
A	31511	8.3%
N	30771	8.1%
L	29178	7.7%
O	28211	7.5%
R	27806	7.4%
E	27661	7.3%
T	22942	6.1%
S	22261	5.9%
Other values (42)	92004	24.4%

Common

Value	Count	Frequency (%)
	54030	59.1%
.	12834	14.0%
,	12327	13.5%
'	2488	2.7%
1	1393	1.5%
&	1221	1.3%
2	1051	1.1%
0	942	1.0%
5	889	1.0%
3	847	0.9%
Other values (16)	3447	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	469040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	54030	11.5%
C	33251	7.1%
I	31975	6.8%
A	31511	6.7%
N	30771	6.6%
L	29178	6.2%
O	28211	6.0%
R	27806	5.9%
E	27661	5.9%
T	22942	4.9%
Other values (68)	151704	32.3%

DOING BUSINESS AS NAME
Text

Distinct	3382
Distinct (%)	15.2%
Missing	1
Missing (%)	< 0.1%
Memory size	173.8 KiB

Length

Max length	88
Median length	48
Mean length	16.865455
Min length	1

Characters and Unicode

Total characters	374801
Distinct characters	77
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	712 ?
Unique (%)	3.2%

Sample

1st row	LIFEWAY KEFIR SHOP
2nd row	JERRY'S SANDWICHES
3rd row	ETTA
4th row	FORK
5th row	RANALLI'S

Value	Count	Frequency (%)
	2640	4.3%
cafe	1547	2.5%
the	1500	2.4%
coffee	1477	2.4%
restaurant	1456	2.4%
bar	1286	2.1%
grill	1143	1.9%
starbucks	973	1.6%
inc	830	1.3%
and	710	1.2%
Other values (3762)	48156	78.0%

Most occurring characters

Value	Count	Frequency (%)
	39644	10.6%
A	31157	8.3%
E	28744	7.7%
R	22102	5.9%
O	21659	5.8%
S	21407	5.7%
I	19401	5.2%
T	19323	5.2%
N	18784	5.0%
C	16294	4.3%
Other values (67)	136286	36.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	296477	79.1%
Space Separator	39644	10.6%
Lowercase Letter	21154	5.6%
Other Punctuation	10380	2.8%
Decimal Number	6579	1.8%
Dash Punctuation	513	0.1%
Math Symbol	50	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	31157	10.5%
E	28744	9.7%
R	22102	7.5%
O	21659	7.3%
S	21407	7.2%
I	19401	6.5%
T	19323	6.5%
N	18784	6.3%
C	16294	5.5%
L	15905	5.4%
Other values (16)	81701	27.6%

Lowercase Letter

Value	Count	Frequency (%)
e	2662	12.6%
a	2574	12.2%
o	1714	8.1%
n	1683	8.0%
i	1560	7.4%
r	1504	7.1%
t	1274	6.0%
s	1236	5.8%
l	1232	5.8%
u	790	3.7%
Other values (15)	4925	23.3%

Other Punctuation

Value	Count	Frequency (%)
'	4575	44.1%
&	2036	19.6%
#	1389	13.4%
.	990	9.5%
,	670	6.5%
/	620	6.0%
"	46	0.4%
!	43	0.4%
@	8	0.1%
;	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	1603	24.4%
1	975	14.8%
4	679	10.3%
3	661	10.0%
5	652	9.9%
0	585	8.9%
7	433	6.6%
6	380	5.8%
8	307	4.7%
9	304	4.6%

Space Separator

Value	Count	Frequency (%)
	39644	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	513	100.0%

Math Symbol

Value	Count	Frequency (%)
+	50	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	317631	84.7%
Common	57170	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	31157	9.8%
E	28744	9.0%
R	22102	7.0%
O	21659	6.8%
S	21407	6.7%
I	19401	6.1%
T	19323	6.1%
N	18784	5.9%
C	16294	5.1%
L	15905	5.0%
Other values (41)	102855	32.4%

Common

Value	Count	Frequency (%)
	39644	69.3%
'	4575	8.0%
&	2036	3.6%
2	1603	2.8%
#	1389	2.4%
.	990	1.7%
1	975	1.7%
4	679	1.2%
,	670	1.2%
3	661	1.2%
Other values (16)	3948	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	374801	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	39644	10.6%
A	31157	8.3%
E	28744	7.7%
R	22102	5.9%
O	21659	5.8%
S	21407	5.7%
I	19401	5.2%
T	19323	5.2%
N	18784	5.0%
C	16294	4.3%
Other values (67)	136286	36.4%

ISSUED DATE
Date

Distinct	3088
Distinct (%)	13.9%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-10-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

EXPIRATION DATE
Date

Distinct	29
Distinct (%)	0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	173.8 KiB

Minimum	2001-11-01 00:00:00
Maximum	2027-04-19 00:00:00

Histogram

Histogram with fixed size bins (bins=29)

PAYMENT DATE
Date

Distinct	3035
Distinct (%)	13.7%
Missing	22
Missing (%)	0.1%
Memory size	173.8 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-10-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ADDRESS
Text

Distinct	2821
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

Length

Max length	34
Median length	24
Mean length	16.555886
Min length	10

Characters and Unicode

Total characters	367938
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	480 ?
Unique (%)	2.2%

Sample

1st row	0 W DIVISION ST
2nd row	4739 N LINCOLN AVE
3rd row	0 N CLARK ST
4th row	4600 N LINCOLN AVE
5th row	0 N LINCOLN AVE

Value	Count	Frequency (%)
n	10707	12.1%
st	10582	12.0%
ave	8589	9.7%
w	7755	8.8%
0	2117	2.4%
e	1886	2.1%
s	1876	2.1%
broadway	1201	1.4%
clark	1189	1.3%
lincoln	1166	1.3%
Other values (2004)	41396	46.8%

Most occurring characters

Value	Count	Frequency (%)
	66240	18.0%
A	24441	6.6%
N	22760	6.2%
E	22613	6.1%
S	21611	5.9%
T	17421	4.7%
W	13312	3.6%
1	13018	3.5%
L	12990	3.5%
R	12803	3.5%
Other values (26)	140729	38.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	227823	61.9%
Decimal Number	73875	20.1%
Space Separator	66240	18.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	24441	10.7%
N	22760	10.0%
E	22613	9.9%
S	21611	9.5%
T	17421	7.6%
W	13312	5.8%
L	12990	5.7%
R	12803	5.6%
O	12372	5.4%
I	11987	5.3%
Other values (15)	55513	24.4%

Decimal Number

Value	Count	Frequency (%)
1	13018	17.6%
0	11566	15.7%
2	9333	12.6%
3	9260	12.5%
5	8187	11.1%
4	7186	9.7%
6	4626	6.3%
7	4201	5.7%
8	3433	4.6%
9	3065	4.1%

Space Separator

Value	Count	Frequency (%)
	66240	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	227823	61.9%
Common	140115	38.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	24441	10.7%
N	22760	10.0%
E	22613	9.9%
S	21611	9.5%
T	17421	7.6%
W	13312	5.8%
L	12990	5.7%
R	12803	5.6%
O	12372	5.4%
I	11987	5.3%
Other values (15)	55513	24.4%

Common

Value	Count	Frequency (%)
	66240	47.3%
1	13018	9.3%
0	11566	8.3%
2	9333	6.7%
3	9260	6.6%
5	8187	5.8%
4	7186	5.1%
6	4626	3.3%
7	4201	3.0%
8	3433	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	367938	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	66240	18.0%
A	24441	6.6%
N	22760	6.2%
E	22613	6.1%
S	21611	5.9%
T	17421	4.7%
W	13312	3.6%
1	13018	3.5%
L	12990	3.5%
R	12803	3.5%
Other values (26)	140729	38.2%

ADDRESS NUMBER START
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1758
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1701.5402

Minimum	0
Maximum	11208
Zeros	2117
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	217
median	1252
Q3	2732
95-th percentile	5024.85
Maximum	11208
Range	11208
Interquartile range (IQR)	2515

Descriptive statistics

Standard deviation	1673.0833
Coefficient of variation (CV)	0.98327581
Kurtosis	0.91617147
Mean	1701.5402
Median Absolute Deviation (MAD)	1103
Skewness	1.1055635
Sum	37815030
Variance	2799207.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2117	9.5%
200	152	0.7%
1	106	0.5%
111	104	0.5%
2100	95	0.4%
20	91	0.4%
400	90	0.4%
175	86	0.4%
731	81	0.4%
100	75	0.3%
Other values (1748)	19227	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2117	9.5%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

ADDRESS NUMBER
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1758
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1701.5402

Minimum	0
Maximum	11208
Zeros	2117
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	217
median	1252
Q3	2732
95-th percentile	5024.85
Maximum	11208
Range	11208
Interquartile range (IQR)	2515

Descriptive statistics

Standard deviation	1673.0833
Coefficient of variation (CV)	0.98327581
Kurtosis	0.91617147
Mean	1701.5402
Median Absolute Deviation (MAD)	1103
Skewness	1.1055635
Sum	37815030
Variance	2799207.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2117	9.5%
200	152	0.7%
1	106	0.5%
111	104	0.5%
2100	95	0.4%
20	91	0.4%
400	90	0.4%
175	86	0.4%
731	81	0.4%
100	75	0.3%
Other values (1748)	19227	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2117	9.5%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

STREET DIRECTION
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

N	10707
W	7755
E	1886
S	1876

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	22224
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	W
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	10707	48.2%
W	7755	34.9%
E	1886	8.5%
S	1876	8.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	10707	48.2%
w	7755	34.9%
e	1886	8.5%
s	1876	8.4%

Most occurring characters

Value	Count	Frequency (%)
N	10707	48.2%
W	7755	34.9%
E	1886	8.5%
S	1876	8.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	22224	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	10707	48.2%
W	7755	34.9%
E	1886	8.5%
S	1876	8.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22224	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	10707	48.2%
W	7755	34.9%
E	1886	8.5%
S	1876	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22224	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	10707	48.2%
W	7755	34.9%
E	1886	8.5%
S	1876	8.4%

STREET
Text

Distinct	233
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

Length

Max length	24
Median length	17
Mean length	7.025153
Min length	3

Characters and Unicode

Total characters	156127
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	0.1%

Sample

1st row	DIVISION
2nd row	LINCOLN
3rd row	CLARK
4th row	LINCOLN
5th row	LINCOLN

Value	Count	Frequency (%)
broadway	1201	5.2%
clark	1189	5.1%
lincoln	1166	5.0%
wells	1139	4.9%
division	940	4.1%
michigan	729	3.1%
milwaukee	693	3.0%
southport	666	2.9%
randolph	658	2.8%
state	538	2.3%
Other values (235)	14233	61.5%

Most occurring characters

Value	Count	Frequency (%)
A	15852	10.2%
L	12449	8.0%
O	12372	7.9%
E	12138	7.8%
N	12053	7.7%
I	11987	7.7%
R	11945	7.7%
S	9193	5.9%
D	7355	4.7%
T	6798	4.4%
Other values (25)	43985	28.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	154260	98.8%
Decimal Number	939	0.6%
Space Separator	928	0.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	15852	10.3%
L	12449	8.1%
O	12372	8.0%
E	12138	7.9%
N	12053	7.8%
I	11987	7.8%
R	11945	7.7%
S	9193	6.0%
D	7355	4.8%
T	6798	4.4%
Other values (15)	42118	27.3%

Decimal Number

Value	Count	Frequency (%)
3	312	33.2%
5	228	24.3%
1	147	15.7%
8	60	6.4%
6	56	6.0%
7	49	5.2%
2	48	5.1%
9	26	2.8%
4	13	1.4%

Space Separator

Value	Count	Frequency (%)
	928	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	154260	98.8%
Common	1867	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	15852	10.3%
L	12449	8.1%
O	12372	8.0%
E	12138	7.9%
N	12053	7.8%
I	11987	7.8%
R	11945	7.7%
S	9193	6.0%
D	7355	4.8%
T	6798	4.4%
Other values (15)	42118	27.3%

Common

Value	Count	Frequency (%)
	928	49.7%
3	312	16.7%
5	228	12.2%
1	147	7.9%
8	60	3.2%
6	56	3.0%
7	49	2.6%
2	48	2.6%
9	26	1.4%
4	13	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	156127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	15852	10.2%
L	12449	8.0%
O	12372	7.9%
E	12138	7.8%
N	12053	7.7%
I	11987	7.7%
R	11945	7.7%
S	9193	5.9%
D	7355	4.7%
T	6798	4.4%
Other values (25)	43985	28.2%

STREET TYPE
Categorical

IMBALANCE MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	1360
Missing (%)	6.1%
Memory size	173.8 KiB

ST	10542
AVE	8589
RD	658
BLVD	280
PL	261
Other values (4)	534

Length

Max length	4
Median length	2
Mean length	2.4606499
Min length	2

Characters and Unicode

Total characters	51339
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ST
2nd row	AVE
3rd row	ST
4th row	AVE
5th row	AVE

Common Values

Value	Count	Frequency (%)
ST	10542	47.4%
AVE	8589	38.6%
RD	658	3.0%
BLVD	280	1.3%
PL	261	1.2%
PKWY	209	0.9%
DR	200	0.9%
CT	81	0.4%
HWY	44	0.2%
(Missing)	1360	6.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
st	10542	50.5%
ave	8589	41.2%
rd	658	3.2%
blvd	280	1.3%
pl	261	1.3%
pkwy	209	1.0%
dr	200	1.0%
ct	81	0.4%
hwy	44	0.2%

Most occurring characters

Value	Count	Frequency (%)
T	10623	20.7%
S	10542	20.5%
V	8869	17.3%
A	8589	16.7%
E	8589	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	51339	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10623	20.7%
S	10542	20.5%
V	8869	17.3%
A	8589	16.7%
E	8589	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51339	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10623	20.7%
S	10542	20.5%
V	8869	17.3%
A	8589	16.7%
E	8589	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	51339	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10623	20.7%
S	10542	20.5%
V	8869	17.3%
A	8589	16.7%
E	8589	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

CITY
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

CHICAGO	22224

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	155568
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Common Values

Value	Count	Frequency (%)
CHICAGO	22224	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	22224	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	44448	28.6%
H	22224	14.3%
I	22224	14.3%
A	22224	14.3%
G	22224	14.3%
O	22224	14.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	155568	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	44448	28.6%
H	22224	14.3%
I	22224	14.3%
A	22224	14.3%
G	22224	14.3%
O	22224	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	155568	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	44448	28.6%
H	22224	14.3%
I	22224	14.3%
A	22224	14.3%
G	22224	14.3%
O	22224	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	155568	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	44448	28.6%
H	22224	14.3%
I	22224	14.3%
A	22224	14.3%
G	22224	14.3%
O	22224	14.3%

STATE
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

IL	22224

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	44448
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	22224	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	22224	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	22224	50.0%
L	22224	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	44448	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	22224	50.0%
L	22224	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44448	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	22224	50.0%
L	22224	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	44448	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	22224	50.0%
L	22224	50.0%

ZIP CODE
Real number (ℝ)

Distinct	53
Distinct (%)	0.2%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	60626.853

Minimum	60601
Maximum	60707
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	60601
5-th percentile	60603
Q1	60611
median	60618
Q3	60647
95-th percentile	60657
Maximum	60707
Range	106
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	20.303677
Coefficient of variation (CV)	0.00033489579
Kurtosis	-0.95246262
Mean	60626.853
Median Absolute Deviation (MAD)	11
Skewness	0.57200447
Sum	1.3471893 × 10⁹
Variance	412.23932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60657	2234	10.1%
60611	1869	8.4%
60654	1774	8.0%
60622	1758	7.9%
60614	1664	7.5%
60607	1327	6.0%
60613	1170	5.3%
60647	967	4.4%
60610	951	4.3%
60618	908	4.1%
Other values (43)	7599	34.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60601	656	3.0%
60602	410	1.8%
60603	331	1.5%
60604	234	1.1%
60605	729	3.3%
60606	385	1.7%
60607	1327	6.0%
60608	213	1.0%
60609	32	0.1%
60610	951	4.3%

Value	Count	Frequency (%)
60707	47	0.2%
60661	506	2.3%
60660	350	1.6%
60659	203	0.9%
60657	2234	10.1%
60656	17	0.1%
60655	3	< 0.1%
60654	1774	8.0%
60653	23	0.1%
60651	3	< 0.1%

WARD
Real number (ℝ)

HIGH CORRELATION

Distinct	44
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.356686

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	27
median	42
Q3	44
95-th percentile	47
Maximum	50
Range	49
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	16.140665
Coefficient of variation (CV)	0.49883553
Kurtosis	-0.46121055
Mean	32.356686
Median Absolute Deviation (MAD)	5
Skewness	-1.0442388
Sum	719095
Variance	260.52106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
42	5595	25.2%
44	2204	9.9%
27	1698	7.6%
1	1631	7.3%
47	1601	7.2%
2	1392	6.3%
43	1278	5.8%
32	1192	5.4%
4	672	3.0%
46	624	2.8%
Other values (34)	4337	19.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1631	7.3%
2	1392	6.3%
3	293	1.3%
4	672	3.0%
5	104	0.5%
6	1	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	13	0.1%
11	338	1.5%

Value	Count	Frequency (%)
50	109	0.5%
49	164	0.7%
48	606	2.7%
47	1601	7.2%
46	624	2.8%
45	270	1.2%
44	2204	9.9%
43	1278	5.8%
42	5595	25.2%
41	91	0.4%

POLICE DISTRICT
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	23
Distinct (%)	0.1%
Missing	881
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.115963

Minimum	0
Maximum	25
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	12
median	18
Q3	19
95-th percentile	20
Maximum	25
Range	25
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	6.7903667
Coefficient of variation (CV)	0.48104169
Kurtosis	-0.23967879
Mean	14.115963
Median Absolute Deviation (MAD)	1
Skewness	-1.0661788
Sum	301277
Variance	46.10908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
18	5343	24.0%
19	5064	22.8%
1	3661	16.5%
12	2507	11.3%
14	1789	8.0%
20	988	4.4%
16	419	1.9%
17	374	1.7%
24	364	1.6%
2	238	1.1%
Other values (13)	596	2.7%
(Missing)	881	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	3661	16.5%
2	238	1.1%
3	10	< 0.1%
4	15	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	44	0.2%
9	224	1.0%

Value	Count	Frequency (%)
25	149	0.7%
24	364	1.6%
22	27	0.1%
20	988	4.4%
19	5064	22.8%
18	5343	24.0%
17	374	1.7%
16	419	1.9%
15	7	< 0.1%
14	1789	8.0%

LATITUDE
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2727
Distinct (%)	12.8%
Missing	881
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.912361

Minimum	41.69067
Maximum	42.019421
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	41.69067
5-th percentile	41.86652
Q1	41.885856
median	41.903246
Q3	41.942224
95-th percentile	41.978607
Maximum	42.019421
Range	0.32875146
Interquartile range (IQR)	0.056368381

Descriptive statistics

Standard deviation	0.038255021
Coefficient of variation (CV)	0.00091273839
Kurtosis	1.5813341
Mean	41.912361
Median Absolute Deviation (MAD)	0.021535653
Skewness	-0.14545186
Sum	894535.52
Variance	0.0014634466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88200199	98	0.4%
41.88197573	96	0.4%
41.90405052	85	0.4%
41.87801449	81	0.4%
41.88460018	69	0.3%
41.8825402	53	0.2%
41.90186736	40	0.2%
41.89678605	40	0.2%
41.88216417	37	0.2%
41.87949547	37	0.2%
Other values (2717)	20707	93.2%
(Missing)	881	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.69066951	1	< 0.1%
41.69139989	2	< 0.1%
41.69245222	1	< 0.1%
41.69920305	10	< 0.1%
41.70289718	1	< 0.1%
41.70356373	2	< 0.1%
41.71874411	1	< 0.1%
41.72107515	10	< 0.1%
41.72112515	1	< 0.1%
41.72177014	1	< 0.1%

Value	Count	Frequency (%)
42.01942097	12	0.1%
42.0193885	5	< 0.1%
42.01934594	4	< 0.1%
42.01933013	3	< 0.1%
42.01932963	2	< 0.1%
42.0193098	4	< 0.1%
42.01927235	1	< 0.1%
42.0174068	8	< 0.1%
42.01615704	15	0.1%
42.01615267	15	0.1%

LONGITUDE
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2727
Distinct (%)	12.8%
Missing	881
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.65498

Minimum	-87.834308
Maximum	-87.535139
Zeros	0
Zeros (%)	0.0%
Negative	21343
Negative (%)	96.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	-87.834308
5-th percentile	-87.708499
Q1	-87.670876
median	-87.648725
Q3	-87.630587
95-th percentile	-87.624293
Maximum	-87.535139
Range	0.29916895
Interquartile range (IQR)	0.040289762

Descriptive statistics

Standard deviation	0.032512663
Coefficient of variation (CV)	-0.00037091633
Kurtosis	5.619999
Mean	-87.65498
Median Absolute Deviation (MAD)	0.0196747
Skewness	-1.8306663
Sum	-1870820.2
Variance	0.0010570733
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.63103164	98	0.4%
-87.63397185	96	0.4%
-87.62874675	85	0.4%
-87.63318903	81	0.4%
-87.62798897	69	0.3%
-87.62453095	53	0.2%
-87.62849214	40	0.2%
-87.62828088	40	0.2%
-87.62451427	37	0.2%
-87.63382966	37	0.2%
Other values (2717)	20707	93.2%
(Missing)	881	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.8343079	1	< 0.1%
-87.82625503	9	< 0.1%
-87.82618448	1	< 0.1%
-87.82167425	5	< 0.1%
-87.82042719	4	< 0.1%
-87.81865423	16	0.1%
-87.81795264	4	< 0.1%
-87.81783297	3	< 0.1%
-87.81729036	11	< 0.1%
-87.8172596	2	< 0.1%

Value	Count	Frequency (%)
-87.53513895	2	< 0.1%
-87.55117213	1	< 0.1%
-87.55124869	1	< 0.1%
-87.55161886	9	< 0.1%
-87.56729719	2	< 0.1%
-87.58184369	4	< 0.1%
-87.58390766	1	< 0.1%
-87.58502961	2	< 0.1%
-87.58781452	8	< 0.1%
-87.58797399	7	< 0.1%

LOCATION
Text

MISSING

Distinct	2727
Distinct (%)	12.8%
Missing	881
Missing (%)	4.0%
Memory size	173.8 KiB

Length

Max length	40
Median length	39
Mean length	39.102188
Min length	35

Characters and Unicode

Total characters	834558
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	465 ?
Unique (%)	2.2%

Sample

1st row	(41.90405051948726, -87.62874675447662)
2nd row	(41.96769881732379, -87.68780818484225)
3rd row	(41.88200198545344, -87.6310316367502)
4th row	(41.964902360748326, -87.68627917084095)
5th row	(41.94330292584782, -87.67135515305324)

Value	Count	Frequency (%)
41.88200198545344	98	0.2%
87.6310316367502	98	0.2%
41.881975727713886	96	0.2%
87.63397184627037	96	0.2%
41.90405051948726	85	0.2%
87.62874675447662	85	0.2%
41.878014487249544	81	0.2%
87.63318903001444	81	0.2%
87.62798896732363	69	0.2%
41.884600177780484	69	0.2%
Other values (5444)	41828	98.0%

Most occurring characters

Value	Count	Frequency (%)
8	89104	10.7%
4	80710	9.7%
7	78196	9.4%
6	76501	9.2%
1	74199	8.9%
9	66929	8.0%
2	56939	6.8%
3	56179	6.7%
5	55900	6.7%
0	50500	6.1%
Other values (6)	149401	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	685157	82.1%
Other Punctuation	64029	7.7%
Open Punctuation	21343	2.6%
Space Separator	21343	2.6%
Dash Punctuation	21343	2.6%
Close Punctuation	21343	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	89104	13.0%
4	80710	11.8%
7	78196	11.4%
6	76501	11.2%
1	74199	10.8%
9	66929	9.8%
2	56939	8.3%
3	56179	8.2%
5	55900	8.2%
0	50500	7.4%

Other Punctuation

Value	Count	Frequency (%)
.	42686	66.7%
,	21343	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	21343	100.0%

Space Separator

Value	Count	Frequency (%)
	21343	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	21343	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	21343	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	834558	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	89104	10.7%
4	80710	9.7%
7	78196	9.4%
6	76501	9.2%
1	74199	8.9%
9	66929	8.0%
2	56939	6.8%
3	56179	6.7%
5	55900	6.7%
0	50500	6.1%
Other values (6)	149401	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	834558	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	89104	10.7%
4	80710	9.7%
7	78196	9.4%
6	76501	9.2%
1	74199	8.9%
9	66929	8.0%
2	56939	6.8%
3	56179	6.7%
5	55900	6.7%
0	50500	6.1%
Other values (6)	149401	17.9%

Auto

Heatmap
Table

	PERMIT NUMBER	ACCOUNT NUMBER	SITE NUMBER	ADDRESS NUMBER START	ADDRESS NUMBER	ZIP CODE	WARD	POLICE DISTRICT	LATITUDE	LONGITUDE	STREET DIRECTION	STREET TYPE
PERMIT NUMBER	1.000	0.473	0.010	-0.255	-0.255	-0.003	-0.051	-0.149	-0.136	0.037	0.029	0.002
ACCOUNT NUMBER	0.473	1.000	-0.186	-0.141	-0.141	-0.035	-0.087	-0.143	-0.124	0.016	0.071	0.068
SITE NUMBER	0.010	-0.186	1.000	-0.107	-0.107	-0.089	0.060	-0.053	-0.072	0.142	0.069	0.056
ADDRESS NUMBER START	-0.255	-0.141	-0.107	1.000	1.000	0.361	0.227	0.561	0.734	-0.720	0.298	0.197
ADDRESS NUMBER	-0.255	-0.141	-0.107	1.000	1.000	0.361	0.227	0.561	0.734	-0.720	0.298	0.197
ZIP CODE	-0.003	-0.035	-0.089	0.361	0.361	1.000	0.247	0.488	0.475	-0.444	0.314	0.225
WARD	-0.051	-0.087	0.060	0.227	0.227	0.247	1.000	0.563	0.518	-0.070	0.296	0.167
POLICE DISTRICT	-0.149	-0.143	-0.053	0.561	0.561	0.488	0.563	1.000	0.829	-0.342	0.392	0.186
LATITUDE	-0.136	-0.124	-0.072	0.734	0.734	0.475	0.518	0.829	1.000	-0.621	0.392	0.212
LONGITUDE	0.037	0.016	0.142	-0.720	-0.720	-0.444	-0.070	-0.342	-0.621	1.000	0.317	0.268
STREET DIRECTION	0.029	0.071	0.069	0.298	0.298	0.314	0.296	0.392	0.392	0.317	1.000	0.242
STREET TYPE	0.002	0.068	0.056	0.197	0.197	0.225	0.167	0.186	0.212	0.268	0.242	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	PERMIT NUMBER	ACCOUNT NUMBER	SITE NUMBER	LEGAL NAME	DOING BUSINESS AS NAME	ISSUED DATE	EXPIRATION DATE	PAYMENT DATE	ADDRESS	ADDRESS NUMBER START	ADDRESS NUMBER	STREET DIRECTION	STREET	STREET TYPE	CITY	STATE	ZIP CODE	WARD	POLICE DISTRICT	LATITUDE	LONGITUDE	LOCATION
0	1556602	328992	1	THE LIFEWAY KEFIR SHOP LLC	LIFEWAY KEFIR SHOP	07/16/2021	02/28/2022	07/16/2021	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	1	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
1	1531303	399498	1	JERRY'S SANDWICHES LS, LLC	JERRY'S SANDWICHES	07/16/2021	02/28/2022	07/16/2021	4739 N LINCOLN AVE	4739	4739	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.967699	-87.687808	(41.96769881732379, -87.68780818484225)
2	1553078	463188	1	ETTA RIVER NORTH, LLC	ETTA	07/16/2021	02/28/2022	07/16/2021	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	2	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)
3	1534556	252742	1	SQUARE KITCHEN, LLC	FORK	07/16/2021	02/28/2022	07/16/2021	4600 N LINCOLN AVE	4600	4600	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.964902	-87.686279	(41.964902360748326, -87.68627917084095)
4	1556006	337178	1	ROCCO'S, LLC	RANALLI'S	07/16/2021	02/28/2022	07/16/2021	0 N LINCOLN AVE	0	0	N	LINCOLN	AVE	CHICAGO	IL	60614.0	43	NaN	NaN	NaN	None
5	1536621	414414	1	BBSC #4 LLC	BROWN BAG SEAFOOD CO.	07/16/2021	02/28/2022	07/16/2021	3400 N LINCOLN AVE	3400	3400	N	LINCOLN	AVE	CHICAGO	IL	60657.0	47	19.0	41.943303	-87.671355	(41.94330292584782, -87.67135515305324)
6	1559950	34063	1	GASTHAUS ZUM LOEWEN, INC.	THE REVELER	07/16/2021	02/28/2022	07/16/2021	0 W ROSCOE ST	0	0	W	ROSCOE	ST	CHICAGO	IL	60657.0	32	NaN	NaN	NaN	None
7	1540360	23957	1	TEMPO CAFE LIMITED	TEMPO CAFE	07/16/2021	02/28/2022	07/15/2021	6 E CHESTNUT ST	6	6	E	CHESTNUT	ST	CHICAGO	IL	60611.0	2	18.0	41.898431	-87.628009	(41.89843137207629, -87.6280091630558)
8	1543349	425540	1	MI FOGATA INC.	MI FOGATA INC.	07/16/2021	02/28/2022	07/16/2021	4322 N WESTERN AVE	4322	4322	N	WESTERN	AVE	CHICAGO	IL	60618.0	47	19.0	41.960229	-87.688800	(41.96022917610446, -87.68880023680377)
9	1555187	340126	1	SHINE RESTAURANT CORP.	SHINE RESTAURANT, RISE SUSHI RESTAURANT	07/17/2021	02/28/2022	07/14/2021	0 W WEBSTER AVE	0	0	W	WEBSTER	AVE	CHICAGO	IL	60614.0	43	NaN	NaN	NaN	None

	PERMIT NUMBER	ACCOUNT NUMBER	SITE NUMBER	LEGAL NAME	DOING BUSINESS AS NAME	ISSUED DATE	EXPIRATION DATE	PAYMENT DATE	ADDRESS	ADDRESS NUMBER START	ADDRESS NUMBER	STREET DIRECTION	STREET	STREET TYPE	CITY	STATE	ZIP CODE	WARD	POLICE DISTRICT	LATITUDE	LONGITUDE	LOCATION
22214	1816017	490229	1	LA ESQUINA DEL TACO INC.,	LA ESQUINA DEL TACO	06/21/2023	02/29/2024	06/21/2023	3259 W 63RD ST	3259	3259	W	63RD	ST	CHICAGO	IL	60629.0	14	8.0	41.778828	-87.705434	(41.77882757627881, -87.70543426650146)
22215	1829707	426327	1	MINI MOTT CO.	MINI MOTT	06/22/2023	02/29/2024	06/22/2023	0 W LOGAN BLVD	0	0	W	LOGAN	BLVD	CHICAGO	IL	60647.0	1	NaN	NaN	NaN	None
22216	1827202	482604	2	PWU DUMMY ACCOUNT	PWU DUMMY ACCOUNT	06/22/2023	02/29/2024	06/22/2023	3328 N LINCOLN AVE	3328	3328	N	LINCOLN	AVE	CHICAGO	IL	60657.0	32	19.0	41.942385	-87.670714	(41.94238547241118, -87.67071383788313)
22217	1779815	258836	1	WHITE LODGING SERVICES CORPORATION	COURTYARD BY MARRIOTT	06/22/2023	02/29/2024	06/22/2023	0 E ONTARIO ST	0	0	E	ONTARIO	ST	CHICAGO	IL	60611.0	42	18.0	41.893383	-87.628054	(41.89338314403168, -87.62805370484159)
22218	1828620	7533	1	LA BRUQUENA RESTAURANT & LOUNGE, INC.	LA BRUQUENA RESTAURANT & LOUNGE	06/23/2023	02/29/2024	06/23/2023	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	26	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
22219	1802375	8020	1	MUSES FOOD & LIQUOR, INC.	9 MUSES BAR & GRILL	06/23/2023	02/29/2024	06/23/2023	0 S HALSTED ST	0	0	S	HALSTED	ST	CHICAGO	IL	60661.0	27	12.0	41.881710	-87.647504	(41.88171010567303, -87.6475041570745)
22220	1815670	294329	1	RICHMOND TAVERN, INC.	RICHMOND TAVERN	06/27/2023	02/29/2024	06/27/2023	2944 W GRAND AVE	2944	2944	W	GRAND	AVE	CHICAGO	IL	60622.0	36	12.0	41.896089	-87.700748	(41.89608917059594, -87.70074823336402)
22221	1815487	486699	1	CASA AMIGOS RESTAURANT BAR LLC	LOS MOLCAJETES RESTAURANT BAR	06/27/2023	02/29/2024	06/27/2023	3830 W LAWRENCE AVE	3830	3830	W	LAWRENCE	AVE	CHICAGO	IL	60625.0	35	17.0	41.968390	-87.724448	(41.968390431264375, -87.72444785924317)
22222	1834781	463188	1	ETTA RIVER NORTH, LLC	ETTA	06/27/2023	02/29/2024	06/27/2023	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	42	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)
22223	1804536	474539	2	PEDESTRIAN COFFEE LLC	THE COFFEE STUDIO	06/27/2023	02/29/2024	06/27/2023	5628 N CLARK ST	5628	5628	N	CLARK	ST	CHICAGO	IL	60660.0	40	20.0	41.984385	-87.669099	(41.984384824892075, -87.66909931387195)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values